﻿CREATE TABLE [dbo].[impProjectCases] (
    [ImpID]        INT            IDENTITY (1, 1) NOT NULL,
    [Name]         NVARCHAR (255) NULL,
    [Project]      NVARCHAR (255) NULL,
    [Plz]          NCHAR (10)     NULL,
    [Ort]          NVARCHAR (255) NULL,
    [Straße]       NVARCHAR (255) NULL,
    [Erstkontakt]  DATETIME       NULL,
    [Durchführung] DATETIME       NULL,
    [KQ]           NVARCHAR (255) NULL,
    [Auftraggeber] INT            NULL,
    [IsImp]        BIT            CONSTRAINT [DF_impProjectCases_IsImp] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_impProjectCases] PRIMARY KEY CLUSTERED ([ImpID] ASC)
);

